package com.giscloud.limp.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

/**
 * 案件结案信息
 *
 * @author giscloud
 * @email giscloud@giscloud.com
 * @date 2020-07-07 11:22:55
 */
public class CaseCloseExample {
    protected String orderByClause;
    protected boolean distinct;
    protected List<Criteria> oredCriteria;
    public CaseCloseExample() {
        oredCriteria = new ArrayList<Criteria>();
    }
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }
    public String getOrderByClause() {
        return orderByClause;
    }
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }
    public boolean isDistinct() {
        return distinct;
    }
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

                                    public Criteria andCaseCloseIdIsNull() {
                    addCriterion("case_close_id is null");
                    return (Criteria) this;
                }

                public Criteria andCaseCloseIdIsNotNull() {
                    addCriterion("case_close_id is not null");
                    return (Criteria) this;
                }

                public Criteria andCaseCloseIdEqualTo(Integer value) {
                    addCriterion("case_close_id =", value, "caseCloseId");
                    return (Criteria) this;
                }

                public Criteria andCaseCloseIdNotEqualTo(Integer value) {
                    addCriterion("case_close_id <>", value, "caseCloseId");
                    return (Criteria) this;
                }

                public Criteria andCaseCloseIdGreaterThan(Integer value) {
                    addCriterion("case_close_id >", value, "caseCloseId");
                    return (Criteria) this;
                }

                public Criteria andCaseCloseIdGreaterThanOrEqualTo(Integer value) {
                    addCriterion("case_close_id >=", value, "caseCloseId");
                    return (Criteria) this;
                }

                public Criteria andCaseCloseIdLessThan(Integer value) {
                    addCriterion("case_close_id <", value, "caseCloseId");
                    return (Criteria) this;
                }

                public Criteria andCaseCloseIdLessThanOrEqualTo(Integer value) {
                    addCriterion("case_close_id <=", value, "caseCloseId");
                    return (Criteria) this;
                }

                public Criteria andCaseCloseIdIn(List<Integer> values) {
                    addCriterion("case_close_id in", values, "caseCloseId");
                    return (Criteria) this;
                }

                public Criteria andCaseCloseIdNotIn(List<Integer> values) {
                    addCriterion("case_close_id not in", values, "caseCloseId");
                    return (Criteria) this;
                }

                public Criteria andCaseCloseIdBetween(Integer value1, Integer value2) {
                    addCriterion("case_close_id between", value1, value2, "caseCloseId");
                    return (Criteria) this;
                }

                public Criteria andCaseCloseIdNotBetween(Integer value1, Integer value2) {
                    addCriterion("case_close_id not between", value1, value2, "caseCloseId");
                    return (Criteria) this;
                }
                                    public Criteria andCaseIdIsNull() {
                    addCriterion("case_id is null");
                    return (Criteria) this;
                }

                public Criteria andCaseIdIsNotNull() {
                    addCriterion("case_id is not null");
                    return (Criteria) this;
                }

                public Criteria andCaseIdEqualTo(Integer value) {
                    addCriterion("case_id =", value, "caseId");
                    return (Criteria) this;
                }

                public Criteria andCaseIdNotEqualTo(Integer value) {
                    addCriterion("case_id <>", value, "caseId");
                    return (Criteria) this;
                }

                public Criteria andCaseIdGreaterThan(Integer value) {
                    addCriterion("case_id >", value, "caseId");
                    return (Criteria) this;
                }

                public Criteria andCaseIdGreaterThanOrEqualTo(Integer value) {
                    addCriterion("case_id >=", value, "caseId");
                    return (Criteria) this;
                }

                public Criteria andCaseIdLessThan(Integer value) {
                    addCriterion("case_id <", value, "caseId");
                    return (Criteria) this;
                }

                public Criteria andCaseIdLessThanOrEqualTo(Integer value) {
                    addCriterion("case_id <=", value, "caseId");
                    return (Criteria) this;
                }

                public Criteria andCaseIdIn(List<Integer> values) {
                    addCriterion("case_id in", values, "caseId");
                    return (Criteria) this;
                }

                public Criteria andCaseIdNotIn(List<Integer> values) {
                    addCriterion("case_id not in", values, "caseId");
                    return (Criteria) this;
                }

                public Criteria andCaseIdBetween(Integer value1, Integer value2) {
                    addCriterion("case_id between", value1, value2, "caseId");
                    return (Criteria) this;
                }

                public Criteria andCaseIdNotBetween(Integer value1, Integer value2) {
                    addCriterion("case_id not between", value1, value2, "caseId");
                    return (Criteria) this;
                }
                                    public Criteria andClosecaseTypeIsNull() {
                    addCriterion("closecase_type is null");
                    return (Criteria) this;
                }

                public Criteria andClosecaseTypeIsNotNull() {
                    addCriterion("closecase_type is not null");
                    return (Criteria) this;
                }

                public Criteria andClosecaseTypeEqualTo(Integer value) {
                    addCriterion("closecase_type =", value, "closecaseType");
                    return (Criteria) this;
                }

                public Criteria andClosecaseTypeNotEqualTo(Integer value) {
                    addCriterion("closecase_type <>", value, "closecaseType");
                    return (Criteria) this;
                }

                public Criteria andClosecaseTypeGreaterThan(Integer value) {
                    addCriterion("closecase_type >", value, "closecaseType");
                    return (Criteria) this;
                }

                public Criteria andClosecaseTypeGreaterThanOrEqualTo(Integer value) {
                    addCriterion("closecase_type >=", value, "closecaseType");
                    return (Criteria) this;
                }

                public Criteria andClosecaseTypeLessThan(Integer value) {
                    addCriterion("closecase_type <", value, "closecaseType");
                    return (Criteria) this;
                }

                public Criteria andClosecaseTypeLessThanOrEqualTo(Integer value) {
                    addCriterion("closecase_type <=", value, "closecaseType");
                    return (Criteria) this;
                }

                public Criteria andClosecaseTypeIn(List<Integer> values) {
                    addCriterion("closecase_type in", values, "closecaseType");
                    return (Criteria) this;
                }

                public Criteria andClosecaseTypeNotIn(List<Integer> values) {
                    addCriterion("closecase_type not in", values, "closecaseType");
                    return (Criteria) this;
                }

                public Criteria andClosecaseTypeBetween(Integer value1, Integer value2) {
                    addCriterion("closecase_type between", value1, value2, "closecaseType");
                    return (Criteria) this;
                }

                public Criteria andClosecaseTypeNotBetween(Integer value1, Integer value2) {
                    addCriterion("closecase_type not between", value1, value2, "closecaseType");
                    return (Criteria) this;
                }
                                    public Criteria andClosecaseStageIsNull() {
                    addCriterion("closecase_stage is null");
                    return (Criteria) this;
                }

                public Criteria andClosecaseStageIsNotNull() {
                    addCriterion("closecase_stage is not null");
                    return (Criteria) this;
                }

                public Criteria andClosecaseStageEqualTo(Integer value) {
                    addCriterion("closecase_stage =", value, "closecaseStage");
                    return (Criteria) this;
                }

                public Criteria andClosecaseStageNotEqualTo(Integer value) {
                    addCriterion("closecase_stage <>", value, "closecaseStage");
                    return (Criteria) this;
                }

                public Criteria andClosecaseStageGreaterThan(Integer value) {
                    addCriterion("closecase_stage >", value, "closecaseStage");
                    return (Criteria) this;
                }

                public Criteria andClosecaseStageGreaterThanOrEqualTo(Integer value) {
                    addCriterion("closecase_stage >=", value, "closecaseStage");
                    return (Criteria) this;
                }

                public Criteria andClosecaseStageLessThan(Integer value) {
                    addCriterion("closecase_stage <", value, "closecaseStage");
                    return (Criteria) this;
                }

                public Criteria andClosecaseStageLessThanOrEqualTo(Integer value) {
                    addCriterion("closecase_stage <=", value, "closecaseStage");
                    return (Criteria) this;
                }

                public Criteria andClosecaseStageIn(List<Integer> values) {
                    addCriterion("closecase_stage in", values, "closecaseStage");
                    return (Criteria) this;
                }

                public Criteria andClosecaseStageNotIn(List<Integer> values) {
                    addCriterion("closecase_stage not in", values, "closecaseStage");
                    return (Criteria) this;
                }

                public Criteria andClosecaseStageBetween(Integer value1, Integer value2) {
                    addCriterion("closecase_stage between", value1, value2, "closecaseStage");
                    return (Criteria) this;
                }

                public Criteria andClosecaseStageNotBetween(Integer value1, Integer value2) {
                    addCriterion("closecase_stage not between", value1, value2, "closecaseStage");
                    return (Criteria) this;
                }
                            public Criteria andClosecaseDescriptionLike(String value) {
                    addCriterion("closecase_description like", value, "closecaseDescription");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDescriptionNotLike(String value) {
                    addCriterion("closecase_description not like", value, "closecaseDescription");
                    return (Criteria) this;
                }
                            public Criteria andClosecaseDescriptionIsNull() {
                    addCriterion("closecase_description is null");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDescriptionIsNotNull() {
                    addCriterion("closecase_description is not null");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDescriptionEqualTo(String value) {
                    addCriterion("closecase_description =", value, "closecaseDescription");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDescriptionNotEqualTo(String value) {
                    addCriterion("closecase_description <>", value, "closecaseDescription");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDescriptionGreaterThan(String value) {
                    addCriterion("closecase_description >", value, "closecaseDescription");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDescriptionGreaterThanOrEqualTo(String value) {
                    addCriterion("closecase_description >=", value, "closecaseDescription");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDescriptionLessThan(String value) {
                    addCriterion("closecase_description <", value, "closecaseDescription");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDescriptionLessThanOrEqualTo(String value) {
                    addCriterion("closecase_description <=", value, "closecaseDescription");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDescriptionIn(List<String> values) {
                    addCriterion("closecase_description in", values, "closecaseDescription");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDescriptionNotIn(List<String> values) {
                    addCriterion("closecase_description not in", values, "closecaseDescription");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDescriptionBetween(String value1, String value2) {
                    addCriterion("closecase_description between", value1, value2, "closecaseDescription");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDescriptionNotBetween(String value1, String value2) {
                    addCriterion("closecase_description not between", value1, value2, "closecaseDescription");
                    return (Criteria) this;
                }
                            public Criteria andAttachmentIdLike(String value) {
                    addCriterion("attachment_id like", value, "attachmentId");
                    return (Criteria) this;
                }

                public Criteria andAttachmentIdNotLike(String value) {
                    addCriterion("attachment_id not like", value, "attachmentId");
                    return (Criteria) this;
                }
                            public Criteria andAttachmentIdIsNull() {
                    addCriterion("attachment_id is null");
                    return (Criteria) this;
                }

                public Criteria andAttachmentIdIsNotNull() {
                    addCriterion("attachment_id is not null");
                    return (Criteria) this;
                }

                public Criteria andAttachmentIdEqualTo(String value) {
                    addCriterion("attachment_id =", value, "attachmentId");
                    return (Criteria) this;
                }

                public Criteria andAttachmentIdNotEqualTo(String value) {
                    addCriterion("attachment_id <>", value, "attachmentId");
                    return (Criteria) this;
                }

                public Criteria andAttachmentIdGreaterThan(String value) {
                    addCriterion("attachment_id >", value, "attachmentId");
                    return (Criteria) this;
                }

                public Criteria andAttachmentIdGreaterThanOrEqualTo(String value) {
                    addCriterion("attachment_id >=", value, "attachmentId");
                    return (Criteria) this;
                }

                public Criteria andAttachmentIdLessThan(String value) {
                    addCriterion("attachment_id <", value, "attachmentId");
                    return (Criteria) this;
                }

                public Criteria andAttachmentIdLessThanOrEqualTo(String value) {
                    addCriterion("attachment_id <=", value, "attachmentId");
                    return (Criteria) this;
                }

                public Criteria andAttachmentIdIn(List<String> values) {
                    addCriterion("attachment_id in", values, "attachmentId");
                    return (Criteria) this;
                }

                public Criteria andAttachmentIdNotIn(List<String> values) {
                    addCriterion("attachment_id not in", values, "attachmentId");
                    return (Criteria) this;
                }

                public Criteria andAttachmentIdBetween(String value1, String value2) {
                    addCriterion("attachment_id between", value1, value2, "attachmentId");
                    return (Criteria) this;
                }

                public Criteria andAttachmentIdNotBetween(String value1, String value2) {
                    addCriterion("attachment_id not between", value1, value2, "attachmentId");
                    return (Criteria) this;
                }
                                    public Criteria andAttachmentReceiveDateIsNull() {
                    addCriterion("attachment_receive_date is null");
                    return (Criteria) this;
                }

                public Criteria andAttachmentReceiveDateIsNotNull() {
                    addCriterion("attachment_receive_date is not null");
                    return (Criteria) this;
                }

                public Criteria andAttachmentReceiveDateEqualTo(Date value) {
                    addCriterion("attachment_receive_date =", value, "attachmentReceiveDate");
                    return (Criteria) this;
                }

                public Criteria andAttachmentReceiveDateNotEqualTo(Date value) {
                    addCriterion("attachment_receive_date <>", value, "attachmentReceiveDate");
                    return (Criteria) this;
                }

                public Criteria andAttachmentReceiveDateGreaterThan(Date value) {
                    addCriterion("attachment_receive_date >", value, "attachmentReceiveDate");
                    return (Criteria) this;
                }

                public Criteria andAttachmentReceiveDateGreaterThanOrEqualTo(Date value) {
                    addCriterion("attachment_receive_date >=", value, "attachmentReceiveDate");
                    return (Criteria) this;
                }

                public Criteria andAttachmentReceiveDateLessThan(Date value) {
                    addCriterion("attachment_receive_date <", value, "attachmentReceiveDate");
                    return (Criteria) this;
                }

                public Criteria andAttachmentReceiveDateLessThanOrEqualTo(Date value) {
                    addCriterion("attachment_receive_date <=", value, "attachmentReceiveDate");
                    return (Criteria) this;
                }

                public Criteria andAttachmentReceiveDateIn(List<Date> values) {
                    addCriterion("attachment_receive_date in", values, "attachmentReceiveDate");
                    return (Criteria) this;
                }

                public Criteria andAttachmentReceiveDateNotIn(List<Date> values) {
                    addCriterion("attachment_receive_date not in", values, "attachmentReceiveDate");
                    return (Criteria) this;
                }

                public Criteria andAttachmentReceiveDateBetween(Date value1, Date value2) {
                    addCriterion("attachment_receive_date between", value1, value2, "attachmentReceiveDate");
                    return (Criteria) this;
                }

                public Criteria andAttachmentReceiveDateNotBetween(Date value1, Date value2) {
                    addCriterion("attachment_receive_date not between", value1, value2, "attachmentReceiveDate");
                    return (Criteria) this;
                }
                            public Criteria andOtherAttachmentIdLike(String value) {
                    addCriterion("other_attachment_id like", value, "otherAttachmentId");
                    return (Criteria) this;
                }

                public Criteria andOtherAttachmentIdNotLike(String value) {
                    addCriterion("other_attachment_id not like", value, "otherAttachmentId");
                    return (Criteria) this;
                }
                            public Criteria andOtherAttachmentIdIsNull() {
                    addCriterion("other_attachment_id is null");
                    return (Criteria) this;
                }

                public Criteria andOtherAttachmentIdIsNotNull() {
                    addCriterion("other_attachment_id is not null");
                    return (Criteria) this;
                }

                public Criteria andOtherAttachmentIdEqualTo(String value) {
                    addCriterion("other_attachment_id =", value, "otherAttachmentId");
                    return (Criteria) this;
                }

                public Criteria andOtherAttachmentIdNotEqualTo(String value) {
                    addCriterion("other_attachment_id <>", value, "otherAttachmentId");
                    return (Criteria) this;
                }

                public Criteria andOtherAttachmentIdGreaterThan(String value) {
                    addCriterion("other_attachment_id >", value, "otherAttachmentId");
                    return (Criteria) this;
                }

                public Criteria andOtherAttachmentIdGreaterThanOrEqualTo(String value) {
                    addCriterion("other_attachment_id >=", value, "otherAttachmentId");
                    return (Criteria) this;
                }

                public Criteria andOtherAttachmentIdLessThan(String value) {
                    addCriterion("other_attachment_id <", value, "otherAttachmentId");
                    return (Criteria) this;
                }

                public Criteria andOtherAttachmentIdLessThanOrEqualTo(String value) {
                    addCriterion("other_attachment_id <=", value, "otherAttachmentId");
                    return (Criteria) this;
                }

                public Criteria andOtherAttachmentIdIn(List<String> values) {
                    addCriterion("other_attachment_id in", values, "otherAttachmentId");
                    return (Criteria) this;
                }

                public Criteria andOtherAttachmentIdNotIn(List<String> values) {
                    addCriterion("other_attachment_id not in", values, "otherAttachmentId");
                    return (Criteria) this;
                }

                public Criteria andOtherAttachmentIdBetween(String value1, String value2) {
                    addCriterion("other_attachment_id between", value1, value2, "otherAttachmentId");
                    return (Criteria) this;
                }

                public Criteria andOtherAttachmentIdNotBetween(String value1, String value2) {
                    addCriterion("other_attachment_id not between", value1, value2, "otherAttachmentId");
                    return (Criteria) this;
                }
                                    public Criteria andStatusCdIsNull() {
                    addCriterion("status_cd is null");
                    return (Criteria) this;
                }

                public Criteria andStatusCdIsNotNull() {
                    addCriterion("status_cd is not null");
                    return (Criteria) this;
                }

                public Criteria andStatusCdEqualTo(Integer value) {
                    addCriterion("status_cd =", value, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdNotEqualTo(Integer value) {
                    addCriterion("status_cd <>", value, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdGreaterThan(Integer value) {
                    addCriterion("status_cd >", value, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdGreaterThanOrEqualTo(Integer value) {
                    addCriterion("status_cd >=", value, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdLessThan(Integer value) {
                    addCriterion("status_cd <", value, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdLessThanOrEqualTo(Integer value) {
                    addCriterion("status_cd <=", value, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdIn(List<Integer> values) {
                    addCriterion("status_cd in", values, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdNotIn(List<Integer> values) {
                    addCriterion("status_cd not in", values, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdBetween(Integer value1, Integer value2) {
                    addCriterion("status_cd between", value1, value2, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdNotBetween(Integer value1, Integer value2) {
                    addCriterion("status_cd not between", value1, value2, "statusCd");
                    return (Criteria) this;
                }
                                    public Criteria andCreatedStaffIdIsNull() {
                    addCriterion("created_staff_id is null");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdIsNotNull() {
                    addCriterion("created_staff_id is not null");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdEqualTo(Integer value) {
                    addCriterion("created_staff_id =", value, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdNotEqualTo(Integer value) {
                    addCriterion("created_staff_id <>", value, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdGreaterThan(Integer value) {
                    addCriterion("created_staff_id >", value, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdGreaterThanOrEqualTo(Integer value) {
                    addCriterion("created_staff_id >=", value, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdLessThan(Integer value) {
                    addCriterion("created_staff_id <", value, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdLessThanOrEqualTo(Integer value) {
                    addCriterion("created_staff_id <=", value, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdIn(List<Integer> values) {
                    addCriterion("created_staff_id in", values, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdNotIn(List<Integer> values) {
                    addCriterion("created_staff_id not in", values, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdBetween(Integer value1, Integer value2) {
                    addCriterion("created_staff_id between", value1, value2, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdNotBetween(Integer value1, Integer value2) {
                    addCriterion("created_staff_id not between", value1, value2, "createdStaffId");
                    return (Criteria) this;
                }
                                    public Criteria andCreatedDtIsNull() {
                    addCriterion("created_dt is null");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtIsNotNull() {
                    addCriterion("created_dt is not null");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtEqualTo(Date value) {
                    addCriterion("created_dt =", value, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtNotEqualTo(Date value) {
                    addCriterion("created_dt <>", value, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtGreaterThan(Date value) {
                    addCriterion("created_dt >", value, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtGreaterThanOrEqualTo(Date value) {
                    addCriterion("created_dt >=", value, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtLessThan(Date value) {
                    addCriterion("created_dt <", value, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtLessThanOrEqualTo(Date value) {
                    addCriterion("created_dt <=", value, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtIn(List<Date> values) {
                    addCriterion("created_dt in", values, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtNotIn(List<Date> values) {
                    addCriterion("created_dt not in", values, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtBetween(Date value1, Date value2) {
                    addCriterion("created_dt between", value1, value2, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtNotBetween(Date value1, Date value2) {
                    addCriterion("created_dt not between", value1, value2, "createdDt");
                    return (Criteria) this;
                }
                                    public Criteria andOperateStaffIdIsNull() {
                    addCriterion("operate_staff_id is null");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdIsNotNull() {
                    addCriterion("operate_staff_id is not null");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdEqualTo(Integer value) {
                    addCriterion("operate_staff_id =", value, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdNotEqualTo(Integer value) {
                    addCriterion("operate_staff_id <>", value, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdGreaterThan(Integer value) {
                    addCriterion("operate_staff_id >", value, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdGreaterThanOrEqualTo(Integer value) {
                    addCriterion("operate_staff_id >=", value, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdLessThan(Integer value) {
                    addCriterion("operate_staff_id <", value, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdLessThanOrEqualTo(Integer value) {
                    addCriterion("operate_staff_id <=", value, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdIn(List<Integer> values) {
                    addCriterion("operate_staff_id in", values, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdNotIn(List<Integer> values) {
                    addCriterion("operate_staff_id not in", values, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdBetween(Integer value1, Integer value2) {
                    addCriterion("operate_staff_id between", value1, value2, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdNotBetween(Integer value1, Integer value2) {
                    addCriterion("operate_staff_id not between", value1, value2, "operateStaffId");
                    return (Criteria) this;
                }
                                    public Criteria andVersionIsNull() {
                    addCriterion("version is null");
                    return (Criteria) this;
                }

                public Criteria andVersionIsNotNull() {
                    addCriterion("version is not null");
                    return (Criteria) this;
                }

                public Criteria andVersionEqualTo(Date value) {
                    addCriterion("version =", value, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionNotEqualTo(Date value) {
                    addCriterion("version <>", value, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionGreaterThan(Date value) {
                    addCriterion("version >", value, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionGreaterThanOrEqualTo(Date value) {
                    addCriterion("version >=", value, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionLessThan(Date value) {
                    addCriterion("version <", value, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionLessThanOrEqualTo(Date value) {
                    addCriterion("version <=", value, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionIn(List<Date> values) {
                    addCriterion("version in", values, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionNotIn(List<Date> values) {
                    addCriterion("version not in", values, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionBetween(Date value1, Date value2) {
                    addCriterion("version between", value1, value2, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionNotBetween(Date value1, Date value2) {
                    addCriterion("version not between", value1, value2, "version");
                    return (Criteria) this;
                }
                                    public Criteria andClosecaseDateIsNull() {
                    addCriterion("closecase_date is null");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDateIsNotNull() {
                    addCriterion("closecase_date is not null");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDateEqualTo(Date value) {
                    addCriterion("closecase_date =", value, "closecaseDate");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDateNotEqualTo(Date value) {
                    addCriterion("closecase_date <>", value, "closecaseDate");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDateGreaterThan(Date value) {
                    addCriterion("closecase_date >", value, "closecaseDate");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDateGreaterThanOrEqualTo(Date value) {
                    addCriterion("closecase_date >=", value, "closecaseDate");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDateLessThan(Date value) {
                    addCriterion("closecase_date <", value, "closecaseDate");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDateLessThanOrEqualTo(Date value) {
                    addCriterion("closecase_date <=", value, "closecaseDate");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDateIn(List<Date> values) {
                    addCriterion("closecase_date in", values, "closecaseDate");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDateNotIn(List<Date> values) {
                    addCriterion("closecase_date not in", values, "closecaseDate");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDateBetween(Date value1, Date value2) {
                    addCriterion("closecase_date between", value1, value2, "closecaseDate");
                    return (Criteria) this;
                }

                public Criteria andClosecaseDateNotBetween(Date value1, Date value2) {
                    addCriterion("closecase_date not between", value1, value2, "closecaseDate");
                    return (Criteria) this;
                }
                            public Criteria andResolutionAttachmentLike(String value) {
                    addCriterion("resolution_attachment like", value, "resolutionAttachment");
                    return (Criteria) this;
                }

                public Criteria andResolutionAttachmentNotLike(String value) {
                    addCriterion("resolution_attachment not like", value, "resolutionAttachment");
                    return (Criteria) this;
                }
                            public Criteria andResolutionAttachmentIsNull() {
                    addCriterion("resolution_attachment is null");
                    return (Criteria) this;
                }

                public Criteria andResolutionAttachmentIsNotNull() {
                    addCriterion("resolution_attachment is not null");
                    return (Criteria) this;
                }

                public Criteria andResolutionAttachmentEqualTo(String value) {
                    addCriterion("resolution_attachment =", value, "resolutionAttachment");
                    return (Criteria) this;
                }

                public Criteria andResolutionAttachmentNotEqualTo(String value) {
                    addCriterion("resolution_attachment <>", value, "resolutionAttachment");
                    return (Criteria) this;
                }

                public Criteria andResolutionAttachmentGreaterThan(String value) {
                    addCriterion("resolution_attachment >", value, "resolutionAttachment");
                    return (Criteria) this;
                }

                public Criteria andResolutionAttachmentGreaterThanOrEqualTo(String value) {
                    addCriterion("resolution_attachment >=", value, "resolutionAttachment");
                    return (Criteria) this;
                }

                public Criteria andResolutionAttachmentLessThan(String value) {
                    addCriterion("resolution_attachment <", value, "resolutionAttachment");
                    return (Criteria) this;
                }

                public Criteria andResolutionAttachmentLessThanOrEqualTo(String value) {
                    addCriterion("resolution_attachment <=", value, "resolutionAttachment");
                    return (Criteria) this;
                }

                public Criteria andResolutionAttachmentIn(List<String> values) {
                    addCriterion("resolution_attachment in", values, "resolutionAttachment");
                    return (Criteria) this;
                }

                public Criteria andResolutionAttachmentNotIn(List<String> values) {
                    addCriterion("resolution_attachment not in", values, "resolutionAttachment");
                    return (Criteria) this;
                }

                public Criteria andResolutionAttachmentBetween(String value1, String value2) {
                    addCriterion("resolution_attachment between", value1, value2, "resolutionAttachment");
                    return (Criteria) this;
                }

                public Criteria andResolutionAttachmentNotBetween(String value1, String value2) {
                    addCriterion("resolution_attachment not between", value1, value2, "resolutionAttachment");
                    return (Criteria) this;
                }
            }


}